//===============================================================================
// Microsoft Architecture Strategy Team
// LitwareHR - SaaS Sample Application
//===============================================================================
// Copyright  Microsoft Corporation.  All rights reserved.
// THIS CODE AND INFORMATION IS PROVIDED "AS IS" WITHOUT WARRANTY
// OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT
// LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND
// FITNESS FOR A PARTICULAR PURPOSE.
//===============================================================================
// The example companies, organizations, products, domain names,
// e-mail addresses, logos, people, places, and events depicted
// herein are fictitious.  No association with any real company,
// organization, product, domain name, email address, logo, person,
// places, or events is intended or should be inferred.
//===============================================================================



using System;
using System.Collections.Generic;
using System.Text;
using System.Data.Common;
using System.Data;
using Microsoft.Practices.EnterpriseLibrary.Data;

namespace Shp.Runtime.DataModel.Sql
{
    public class SystemDataModel
    {
        public Guid GetTenantId(string tenantAlias)
        {
            Guid tenantId = Guid.Empty;
            Database db = DatabaseFactory.CreateDatabase(Constants.DB.TenantMetadataStore);
            using (DbCommand command = db.GetStoredProcCommand("dbo.GetTenantId"))
            {
                db.AddInParameter(command, "tenantAlias", DbType.String, tenantAlias);
                tenantId = (Guid)db.ExecuteScalar(command);
            }
            return tenantId;
        }

        public string GetTenantAlias(Guid tenantId)
        {
            string tenatAlias;
            Database db = DatabaseFactory.CreateDatabase(Constants.DB.TenantMetadataStore);
            using (DbCommand command = db.GetStoredProcCommand("dbo.GetTenantAliasById"))
            {
                db.AddInParameter(command, "tenantId", DbType.Guid, tenantId);
                tenatAlias = (string)db.ExecuteScalar(command);
            }
            return tenatAlias;
        }
    }
}
